package cn.sieis.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import cn.sieis.pojo.Student;

public interface StudentMapper {

	public List<Student> getStudentList(@Param("stuName") String stuName, @Param("stuSchool") Integer stuSchool, @Param("stuProject") Integer stuProject, @Param("stuContest") Integer stuContest, @Param("from") Integer currentPageNo, @Param("pageSize") Integer pageSize) throws Exception;

	public int getStudentCount(@Param("stuName") String stuName, @Param("stuSchool") Integer stuSchool, @Param("stuProject") Integer stuProject, @Param("stuContest") Integer stuContest) throws Exception;

	public int addStudent(Student student) throws Exception;

	public int modify(Student student) throws Exception;

	public Student getStudentById(@Param("id") Integer id) throws Exception;

	public int deleteStudentById(@Param("id") Integer id) throws Exception;

	public List<Student> getStuList(@Param("stuName") String stuName, @Param("stuSchool") Integer stuSchool, @Param("stuProject") Integer stuProject, @Param("stuContest") Integer stuContest) throws Exception;

	public int register(Student student); 

	public List<Student> getStudentListFr(@Param("stuName") String stuName, @Param("stuProject") Integer stuProject) throws Exception;
}
